﻿<%@ Page Title="" Language="C#" MasterPageFile="~/teacheryemian/teachermain.Master" AutoEventWireup="true" CodeBehind="teaxueshengxinxichaxun.aspx.cs" Inherits="zlh.teacheryemian.teaxueshengxinxichaxun" %>
<asp:Content ID="Content1" ContentPlaceHolderID="teaContentPlaceHolder1" runat="server">
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Label ID="coursename" runat="server" CssClass="word" Text="学生学号："></asp:Label>
<asp:TextBox ID="counametxt" runat="server" CssClass="textbox"></asp:TextBox>
<asp:Button ID="selectname" runat="server" CssClass="button" Text="Button" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" HorizontalAlign="Center" DataKeyNames="stuNo" Width="729px">
    <Columns>
        <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" ReadOnly="True" />
        <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
        <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
        <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
        <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
        <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major" />
        <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
        <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
        <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
    </Columns>
    <HeaderStyle CssClass="gridxiewHeaderstyle" />
    <RowStyle CssClass="gridviewrowstyle" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString14 %>" SelectCommand="SELECT * FROM [StudentInformation] WHERE ([stuNo] = @stuNo)">
    <SelectParameters>
        <asp:ControlParameter ControlID="counametxt" Name="stuNo" PropertyName="Text" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Label ID="coursename0" runat="server" CssClass="word" Text="学生名字："></asp:Label>
<asp:TextBox ID="counametxt0" runat="server" CssClass="textbox"></asp:TextBox>
<asp:Button ID="selectname0" runat="server" CssClass="button" Text="Button" />
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" HorizontalAlign="Center" DataKeyNames="stuNo" Width="736px">
    <Columns>
        <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" ReadOnly="True" />
        <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
        <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
        <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
        <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
        <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major" />
        <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
        <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
        <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
    </Columns>
    <HeaderStyle CssClass="gridxiewHeaderstyle" />
    <RowStyle CssClass="gridviewrowstyle" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString14 %>" SelectCommand="SELECT * FROM [StudentInformation] WHERE ([stuName] = @stuName)">
    <SelectParameters>
        <asp:ControlParameter ControlID="counametxt0" Name="stuName" PropertyName="Text" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3" HorizontalAlign="Center" AllowPaging="True" DataKeyNames="stuNo" Width="742px">
    <Columns>
        <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" ReadOnly="True" />
        <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
        <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
        <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
        <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
        <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major" />
        <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
        <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
        <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
    </Columns>
    <HeaderStyle CssClass="gridxiewHeaderstyle" />
    <RowStyle CssClass="gridviewrowstyle" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString14 %>" SelectCommand="SELECT * FROM [StudentInformation]">
</asp:SqlDataSource>
    </p>
</asp:Content>
<asp:Content ID="Content2" runat="server" contentplaceholderid="ContentPlaceHolder1">
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem Value="1">蓝色系</asp:ListItem>
        <asp:ListItem Value="2">红色系</asp:ListItem>
        <asp:ListItem Value="3">棕色系</asp:ListItem>
    </asp:DropDownList>
</asp:Content>

